package com.example.pjy.mapper;

import com.example.pjy.pojo.Student;
import com.example.pjy.pojo.Studentin2;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.List;

@Mapper
public interface Studentin2Mapper {


    @Select("select * from studentin2 order by calscore desc")
    List<Studentin2> list();


    //更改该学生的计算成绩
    @Update("update studentin2 set calScore = #{calScore},award = #{award} where studentId=#{studentId}")
    void updatest2(Studentin2 studentin2);



    @Select("select * from studentin2 where sname like concat ('%',#{keyword},'%')")
    List<Studentin2> selectbyname(String keyword);
}
